{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","REG"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[16,6,21,7],[19,1,21,4],[3,1,3,2],[3,7,5,7],[6,7,7,7],[15,1,18,4],[8,7,9,7],[10,7,11,7],[12,7,13,7],[3,6,5,6],[6,6,7,6],[8,6,9,6],[10,6,11,6],[12,6,13,6]]}
[]
[null,"Safety Netting in Vision - Referrals & Test Requests"]
[null,null,null,null,null,null,"Tab Name","Search Criteria"]
[null,"Enter Date Range",null,null,"Active Patients = Applied and Permanent",null,"REFERRALS","All read codes in the referral entity only, within date range (excluding Read codes 8HHt%, 8Hn%, 8HH8%, 8H7o%, 8H7h%, 8HlB%)"]
[null,"FROM","TO",null,"Registration Status"]
[null,"2016-06-01","30/06/2017",null,"ACTIVE PATIENTS"]
[null,null,null,null,null,null,"CA_REF","Cancer Read codes (8HHt%, 8Hn%) in the referral entity only, within date range"]
[]
[null,null,null,null,null,null,"URGENT_REFS","Read codes ( 8HH8%, 8H7o%, 8H7h%, 8HlB%) in the referral entity only, within date range"]
[]
[null,null,null,null,null,null,"REQUESTS","All read codes in the request entity only, within date range (excluding Read codes 4131%, 47K%, 5671%)"]
[null,"REFERRALS sheet: Any referral actions dates older than 14 days will be displayed in RED"]
[null,"Referrals with no action dates are filtered out by default (but may be exposed)",null,null,null,null,"DA_REQ","Read codes (4131%, 47K%, 5671%) in the request entity only, within date range"]
[null,"Each COUNT tab will provide an overall picture of outstanding referrals and requests"]
[]
[null,"As all attribute fields from a referral or test request are imported into this workbook, any method may be used in a practice to determine active monitoring and conclusion.\nWe only point out the action date within a referral as one option, because this date can be forwarded to provide continuous monitoring",null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[]
[null,"Once a referral no longer needs monitoring, you should remove the action date within the referral entity to show that its has been completed."]
[]
[]
[null,"NOTE:"]
[null,"This will only work if Vision is on DLM485 or above."]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,null,"On the Security Level tab > Select Medium. Then select the Trusted Publishers tab and tick \"Trust access to Visual Basic Project\""]
[null,null,"Click OK to close the Security window > Close Excel > Reopen this workbook and select \"Enable Macros\""]
[null,null," If dates show an error. Switch on the Analysis ToolPak via Tools menu > Addins"]
[]
[null,"Created:","2016-11-08"]
[null,"Version:",1.1000000000000001]
[null,"Written by:","Bradley Sieve (Vision)"]

{"sheet":"REG","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code"]
["ACTIVE PATIENTS","REG000"]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]